package cn.kgc.bdqn_studentinfomanager.dao.manager;

import cn.kgc.bdqn_studentinfomanager.pojo.vo.AddUserVo;
import cn.kgc.bdqn_studentinfomanager.pojo.vo.ProvinceAndCityVo;
import cn.kgc.bdqn_studentinfomanager.pojo.vo.ReturnManagerInfoVo;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * by Shanshui CC on 2020/12/10 14:31
 */
public interface ManagerMapper {

    /**
     * 点击页面时 加载省份列表
     *
     * @return
     */
    public List<ProvinceAndCityVo> queryProvince();


    /**
     * 管理员添加渠道主管    /   渠道主管添加渠道专员      /       管理员添加咨询师
     *
     * @param addUserVo
     * @return
     */
    public Integer addManagerUserOrCommUserOrConsult(AddUserVo addUserVo);


    public ReturnManagerInfoVo queryManagerInfoById(String id);

    public List<String> queryCommByManagerId(String ExId);

    public List<String> queryRecrByCommId(List<String> CommIdList);

    public Integer queryStudentCount(@Param("RecrIdList") List<String> RecrIdList, @Param("CommIdList")List<String> CommIdList, @Param("stringDate") String stringDate);

    public Integer queryStudentSuccessCount(@Param("CommIdList") List<String> CommIdList, @Param("RecrIdList") List<String> RecrIdList, @Param("stringDate") String stringDate);



    public List<String> queryExecIdByManagerId(String parentId);

    /**
     * 根据渠道管理Id 查询所有专员Id
     * @param id
     * @return
     */
    public List<String> queryCommByExecId(@Param("id") String id, @Param("userName") String userName);


    public ReturnManagerInfoVo queryCommInfoById(String parentId);

    public Integer queryStudentCountByCommId(String parentId);

    public List<String> queryRecrIdByCommId(String parentId);

    public Integer queryStudentCountByRecrList(List<String> RecrList);

    public Integer queryStudentSuccessCountByCommId(String parentId);

    public Integer queryStudentSuccessCountByRecr(List<String> RecrList);

}
